CREATE DEFINER=`computraceqa`@`%` PROCEDURE `computraceqa`.`UpdateUserStatus`(
    IN p_user_id INT,
    IN p_is_deleted bool
)
BEGIN
    DECLARE Message NVARCHAR(50);
    -- Update the is_active and is_deleted status for the specified user_id
    UPDATE user_details
    SET is_active = 0,
        is_deleted = p_is_deleted,
        updated_on = CURRENT_TIMESTAMP
    WHERE user_id = p_user_id;
END